Can I keep the USERINFO file in an SQL or DB2 database?

In version 12.0 and later, Studio stores this information in a database such as SQL or Oracle, which can avoid some problems. For example, if someone accidentally deletes the USERINFO file, the next time a user joins the workspace the database automatically creates new USERINFO.MDX and USERINFO.DBF files with default access.

In prior versions, you can optionally do this. For example, to store the USERINFO.MDX and USERINFO.DBF files in an SQL or DB2 database, there are a couple of INI options you need to set. For instance, be sure to turn off the default encryption:

< UserInfo >

Encrypt = No

Also, be sure to specify the ID in the UniqueTag option. The system expects that column to be unique within the file, therefore, it is the primary key for looking up things. Here is an example:

< DBTable:USERINFO>

DBHandler = ODBC

UniqueTag = ID